Comma Delimiters

[Willo]

Hi,

I have a column that has a comma that I need to seperate, eg the column looks like:

123719,27319

I want to seperate them into 2 seperate columns, I want to this in a transform. Could anyone help please??

Thanks

[peterbaun]

Hi -

Use the Field function :

If Arg = 123719,27319

Field(Arg, ',', 1) will return 123719
Field(Arg, ',', 2) will return 27319

Regards
Peter

[Willo]

Thanks Peter, that works a treat!! :D