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.