Link to home
Start Free TrialLog in
Avatar of pigmentarts
pigmentartsFlag for United Kingdom of Great Britain and Northern Ireland

asked on

trimming strings

i have some strings

eg. value1_id4

need to pull them into two string like value1 and id4 the _ sign shows where one ends and the other starts. how can i do this? also how can i do this in a query loop (say it i have more than one)?


many thanks

Avatar of pigmentarts
pigmentarts
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

ie this value1_id4 to this value1 and id4 please?
ASKER CERTIFIED SOLUTION
Avatar of 73Spyder
73Spyder

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
sounds what i was after many thanks