Audimation Services has been acquired by CaseWare International Learn More.

X
Icon


Blog Image

Removing Quote Marks

Tech Tip for Using @functions to Normalize Data


@Remove can remove any character from a field except one – the double quote. This is because the double quote is used in the function’s syntax: @Remove (String 1, “String 2”) where String 1 is the field name and where String 2, which must be encapsulated in double-quotes, is the character to be removed.

Here is an example. Suppose you have data that is similar to this and you would like to remove the double-quotes:

Name Field with Quote Marks

To remove the double quotes, you would append a new character field and use the @Remove function. However, if you use @Remove(Name,“ “ “) as the parameter for the new field, you will get a syntax error.

To overcome the syntax error, use the @Chr function to define the double quote instead of using the double quote itself. Here’s how the equation would be structured:

@Remove(Name, @Chr(34))

Name Field with Quote Marks Removed

Explanation:

At their most basic, computers work only with numbers. ASCII and Unicode are basically translations from keyboard characters to numbers that computers can understand.

In IDEA, the @Chr function is used to identify keyboard characters as an ASCII or Unicode number. In both ASCII and Unicode tables, “34” is the number assigned to the double-quote. By using the @Chr function, you can avoid the syntax error.

If you have questions about this or other questions about CaseWare IDEA,
please give our Help Desk a call at 888-641-2800 Option 4.
Or email us at [email protected]


CaseWare IDEA , Tech Tip



Posted By

By Audimation Team


Related Posts
Tech Tip: Comparing Databases
Jun 24 One of CaseWare IDEA®’s most valuable features is its ability to connect, compare and match information from different databases to get a complete view of wh...
Explore the Abundant Resources of AuditNet
Nov 14 Currently, I’m living in the Bahamas and working with the Office of the Auditor General to create various data analytics tests that can be applied with Ca...
Tired of Wrangling Cumbersome Client Data?
Jan 24 Have you ever wrangled a file and felt like it won? We will give you 10 (really compelling) reasons to try our data importing services, which save you time, eff...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×