Check for character

[gdellaiera]

Does anyone know the best way to check for a character?

 

I'm looking for an apostrophe ( ' ) at the beginning of a variable (years attended) that are being input by csv. In single record they get typed in '12-'15 but when uploaded in batch, excel will sometimes remove the initial apostrophe (due to it being a command in the software).

 

I'd like the rule to check for the apostrophe and return the variable if there is one and return ' + variable if there isn't.

 

I am thinking that this would have to be an OnRecordStart rule, but other than that I am a little lost.

 

Thanks for any and all help!

[step]

You could do this:

return Field("Years Attended").replace(/'(\d{2})/g, "'$1")

[ThePorge]

I would think your grep would be /'?(\d{2})/g

What you have won't find the first two digit string if the leading apostrophe is not there.