Search found 15 matches

by hesske
Sat Feb 09, 2019 12:56 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Pull Underlined Text With Spreadsheet Reader
Replies: 6
Views: 1345

Re: Pull Underlined Text With Spreadsheet Reader

No worries, I knew this was going to be a very odd case when I posted it. Thanks for all the replies :)
by hesske
Thu Feb 07, 2019 4:59 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Pull Underlined Text With Spreadsheet Reader
Replies: 6
Views: 1345

Re: Pull Underlined Text With Spreadsheet Reader

Thank you Andras and Vladimir. I have zipped and attached Availability_Sheet_All_Days_test.zip a sample of the spreadsheet I am working with. I have scrubbed the names, but left the formatting in tact. I am wanting to pull specifically the records that are underlined. I have gotten a manual way to r...
by hesske
Sat Jan 26, 2019 3:53 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Pull Underlined Text With Spreadsheet Reader
Replies: 6
Views: 1345

Pull Underlined Text With Spreadsheet Reader

Is it possible to pull the bold or underlined formatting with the text in Spreadsheet reader? I have an excel file that has a long string in each cell (very poorly formatted excel file I was given). Some strings are underlined. Those are the cells I need to pull. Is this possible?
Thanks
by hesske
Mon Oct 08, 2018 6:09 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 1661

Re: Parsing dates

Thank you Vladimir. I found a way that produced what I am looking for by adding these lines to my Reformat code and declaring variables and not using the parameters in the code: while (length($in.0.Dates) > 0){ string today = date2str(today(), "M/dd"); string day2 = date2str(dateAdd(today(...
by hesske
Mon Oct 01, 2018 2:14 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 1661

Re: Parsing dates

Thanks again for the graph Vladimir! I do have a follow-up question. It is using the array of dates created, but is a slightly different topic, so please let me know if it would be better to start a new thread for it. Here is the issue: I am now trying to take each date from the array(list) created ...
by hesske
Thu Sep 27, 2018 6:05 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 1661

Re: Parsing dates

Thank you Vladimir. I will adapt what you gave me to meet what I need. Thanks again!
by hesske
Sat Sep 22, 2018 12:36 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 1661

Re: Parsing dates

Forgot to include this part: $out.0.dates = dates;
by hesske
Fri Sep 21, 2018 2:47 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 1661

Parsing dates

I am trying to build an array(list) of dates between a start date and end date. I have been trying it this way in CTL2: date[] dates; if (dateDiff($in.0.end_date, $in.0.start_date, day) >1){ for (date i=dateAdd($in.0.start_date, 1, day); i<$in.0.end_date; dateAdd(i, 1, day)){ append(dates, i); } } T...
by hesske
Tue May 29, 2018 7:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Filtering by Date
Replies: 2
Views: 1138

Re: Filtering by Date

Thanks Vladimir, this is exactly what I needed.
by hesske
Fri May 25, 2018 2:33 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Filtering by Date
Replies: 2
Views: 1138

Filtering by Date

I am trying to find a function that would filter dates by yesterday or 2 days ago if possible. In Java 8 there is a minus() method, in Python there is you can do str(date.today() - timedelta(days=1)), but in ctl2 I see dateAdd() but no dateMinus() or dateSubtract() options. I'm trying to make someth...
by hesske
Fri Feb 02, 2018 5:31 pm
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 3910

Re: Substring of Email Address

Thanks everyone for the good input. :)
by hesske
Thu Jan 04, 2018 10:19 pm
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 3910

Re: Substring of Email Address

Just wanted to let everyone know I found a regex that accomplished what I needed. Here is my code:
replace($in.0.EMAIL_ADDR, "@(\\w+.\\w+)", " "
by hesske
Thu Jan 04, 2018 6:58 pm
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 3910

Re: Substring of Email Address

hesske wrote:Trying to find a way to use a variable after the @ to get all characters after the @ sign.


Sorry, not a variable, but a wildcard to use.
by hesske
Thu Jan 04, 2018 3:36 pm
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 3910

Re: Substring of Email Address

I think I have found a way to do it via the replace expression. The one issue I've run into is there are a few cases where the domain is different than most of the email addresses. Trying to find a way to use a variable after the @ to get all characters after the @ sign.
by hesske
Wed Jan 03, 2018 7:58 pm
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 3910

Substring of Email Address

I hope I haven't overlooked this in the Help section or here on the forum, but I just need a function to get the characters to the left of the "@" in the email address column of my metadata to use as an username in my output flat file. In Excel, you can just use =LEFT(email,FIND("@&qu...

cron