Hello
How can I split below data into new columns?
Example:
RECONCILIATION Ray-704-12-10/01/2017
New Columns
RECONCILIATION1 RECONCILIATION2 RECONCILIATION3 RECONCILIATION4 Ray 704 12 10/1/2017
Thank you
Hello
How can I split below data into new columns?
Example:
RECONCILIATION Ray-704-12-10/01/2017
New Columns
RECONCILIATION1 RECONCILIATION2 RECONCILIATION3 RECONCILIATION4 Ray 704 12 10/1/2017
Thank you
One simple way would be to export the data column as a Text File, and then re-import as a delimited text file, using the dash as the delimiter.
I'd probably create a function that used the Split() function and returned the desired portion.
Ack, I'm a slow typist today! Joe's idea is a good one if it's a one-time process.
That's a good point. If it is something that is going to be done time and time again, creating a non-manual process to do it is probably the best way to go.Joe's idea is a good one if it's a one-time process.
Yes, I would need this to be done more than one time.
I did some research online and found the following code
Reconciliation1: Trim(Left([RECONCILIATION_NUM],InStr([RECONCILIATION_NUM],"-")-1))
This code works and returns Ray. How do I get second part of the string (Reconciliation2 704)?
Thank you
You want to use the Split function, like Paul suggested.
See: https://www.techonthenet.com/access/...ring/split.php