Adding characters to an IP address in a record (100.1.25.25 /32)

[mchadwick]

I have a field that contains an IP Address. The ranges vary significantly meaning some of the octecs have 3 characters and some have 1 or 2. Example; 100.2.25.250 and the next record may be 1.20.25.251. I need to add a "/32" to the end of the IP Address. How can I automate this for all the records? I know I can create an update query, but I'm not sure how I can do this. However, I will say for most of the records the IP Address is the only thing in the field. Some of the fields have multiple IP Addresses.

[June7]

Well, with multiple addresses this becomes complicated. Is this a multi-value field or just a string? If just a string are the addresses separated by ", " (comma and space)?

Multiple data in one field is something I NEVER do.

Why don't you just put the /32 in another field? If every address uses the same mask prefix, why bother even saving to table?

[mchadwick]

That's not a bad idea. The data came from a seperate system (exported into Excel). Some of the fields have only one and would be easy to just add it to the end of those. Others however not going to be easy.

[June7]

Easy or not depends on answers not given. Multi-value or CSV string?

However, this is a different type of data and should not be stored in the same field as the address anyway.