
Anonymous
Not applicable
2015-07-09
02:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
left function
Hi,
How is it possible to load values of some field on the backfront so that only the first 3 symbols could be loaded?
Thank you in advance,
Larisa
1,776 Views
1 Solution
Accepted Solutions

MVP
2015-07-09
02:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 Replies

MVP
2015-07-09
02:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
Left(YourFieldName, 3)

MVP
2015-07-09
02:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You mean
Load(FieldName,3) as NewFieldName
My Mistake:
Updated:
Left(FieldName,3) as NewFieldName
1,558 Views

Partner - Champion III
2015-07-09
02:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
FIRST 3 LOAD
*
FROM xyz.txt (txt);
Load the first 3 rows of the source
1,558 Views
