Knowledge Sessions: ARIS Scripting
Register
ARIS Process Mining in action - Live Demo
Register

View all
Profile picture for user htelgen

 Hi there,

Tried to use a CSV for datafeed. Succeded, but was not able to mask the quotes; didn't work like it should. What could I have done wrong?

Please help.

by Markus von den Driesch
Posted on Tue, 03/23/2010 - 22:51

Could you please provide some sample data, e.g. the CSV file including the quotes?

0
by Hans Telgen Author
Posted on Wed, 03/24/2010 - 08:56

In reply to by kperlich

I would like to provide a sample data file but that is not allowed here.

Maybe a screendump can show it.

0
by Joerg Klueckmann
Posted on Wed, 03/24/2010 - 11:29

Hi Hans,

 

you can upload files in posts. Just choose attachements.

 

Cheers

 

Joerg

0
by Hans Telgen Author
Posted on Wed, 03/24/2010 - 12:22

In reply to by sstein

Are we talking about the same thing?

I have no option attachment to choose. I guess that you do not mean insert/Edit image?

 

Hans

0
by Udo Walsch
Posted on Wed, 03/24/2010 - 15:13

Hi Hans,

The intention of the masking character is the following:

Any text enclosed by a pair of the specified character will be protected from being parsed for the separator character, i.e the string will not be split into columns even if it contains the separator.

For example, consider a CSV-Table like this:

Historical person,Citation

Julius Caesar,"veni, vidi, vici"

This is what e.g. Excel will create if you use the separator character within a cell and save as .csv

In MashZone, the " marks will protect the phrase "veni, vidi, vici" from being split by the comma. However, they will not be removed from the result.

So, the masking option is not about getting rid of some chars. To achieve that, you can use the "Replace text" operator, replacing " by blank.

Cheers,

Udo

0

Featured achievement

Genius
You like to help others solve their problems by answering questions.
Recent Unlocks
  • KF
  • KH
  • RG
  • Profile picture for user Vee_ARIS
  • Profile picture for user smarty
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock