Not sure if I fully understood..
In a field shpg, you want to replace a single letter 'R' with 'Road', but leave every other Word containing 'R' or just starting with 'R' untouched?
'R' --> 'Road'
'noRmal' --> 'noRmal'
'Roadrunner' --> 'Roadrunner'
For just a single letter, i would try
if(trim(shpg) = 'R', 'Road', shpg) as YourNewField,
You could also use a mapping table, but for one single letter replacement, I think it's not necessary.
Hope this helps,
Sorry for being unclear.
Have a look at the screenshot below J:
I only want to change “R” in the Shpg Field and leave everything the way it is. That should result in: AIR, COURIER, ROAD, SEA, TRUCK,
By using the expression I used: replace(Shpg, ‘R’, ‘ROAD’) everything with a ‘R’ is replaced.
Hope u can help!
Thanks for your quick response btw!!
The use of the resident field in your example is not actually required, this will do the same:
if(trim(shpg) = 'R', 'ROAD', shpg) as shpg
Obviously to put it in the context of the original poster, the only the if line is required in place of the current shpg line in the load script.
You're right!! Your expression worked.
I made the mistake by applying the expression to all the tables and then concatenate them. There was only one table where I needed to use the expression.
So I adjusted my script and used your expression to only 1 table.
Again, thanks for all your help!! I really appriciate it.