S
Steve_A
I am going to be receiving data twice a week in a Excel file and one of the
fields has this type of data in it delimited by _ (uncerscores)
Column Name:Release Action ID
R_CN-AA3317.0048_WBS-4.050.3_CNAA-3317|R_CN-AA3317.0257_WBS-4.050.3
I need to put each piece of data between the _ in a seperate field. I have
done this by making a table of the ID and this colum and exporting it and
then reimporting it as _ delimited the joining it back up by ID number but
would like something a bit faster "LOL"
In one record set there may not be any data in the column but the next one
may have 19 or more so I do not know how many columns it will take and can
very from one week to the next (it will always be more, not less)
Thanks for looking
fields has this type of data in it delimited by _ (uncerscores)
Column Name:Release Action ID
R_CN-AA3317.0048_WBS-4.050.3_CNAA-3317|R_CN-AA3317.0257_WBS-4.050.3
I need to put each piece of data between the _ in a seperate field. I have
done this by making a table of the ID and this colum and exporting it and
then reimporting it as _ delimited the joining it back up by ID number but
would like something a bit faster "LOL"
In one record set there may not be any data in the column but the next one
may have 19 or more so I do not know how many columns it will take and can
very from one week to the next (it will always be more, not less)
Thanks for looking