Multiple Text to column delimeters

[hcabs99]

Hi All

Am trying to build a tool which tidies up EANCOM messages (example below) and makes it easier for the end user to read

There is a number of different delimeters used in the file e.g.:

+ :


UNB+UNOC:3+KRAFTUK_KTEST:14+WHS_GB9C_TEST:14+110314:1238+000000004++++1++1'
UNH+000000004+PRODAT:D:96A:UN:EAN002'
BGM+11E:::Material master+201103141238+9'
DTM+137:201103141238:203'
NAD+MR+GB9C::91'


So.can i use text to columns to do multiple splits(number of columns it will produce will vary by message) or is there any VB code to perform the task?

 

[texasalynn]

I would use the macro recorder to walk through the steps you do in the clean up. Then after you finish recording, the macro can be cleaned up to make it generic and then you can use it each time that your data is refreshed.