String replace (or other string functions) in application studio

Kinetic ERP
, ,
1

I thought this would be simple but I couldn’t figure it out.
I have a string table field whose values may or may not contain a know constant suffix “_KUSA”. I am wanting to row-update a TransView column with the value of this field with suffix removed, to use in urls elsewhere. Are there any string manipulation functions we can embed in the expression?

HEY SUCCESS :partying_face: I just stumbled into it by trial and error and a little google:

“{Project.ProjectID}”.replace(“_KUSA”,“”)

image

Oh well will post this anyway in case it helps anyone.

I think the Expressions are basically javascript?

5 Likes
2 
'{Project.ProjectID}'.replace('_KUSA','')
1 Like
3

It worked with double quotes. I have no idea honestly of when to use one or the other.

Regards,
Chris Were

1 Like
4

I never use double quotes, only ever used single.