Hi Kimberly,
The tab character is CHAR(9). You can get a section out of it with the
FIELD function i.e. FIELD1 = FIELD(LINE,CHAR(9), 1). You can also use the
CHANGE function to convert the line into a dynamic array and work with it
like normal:
LINE = CHANGE(LINE, CHAR(9), CHAR(254))
FIELD1 = LINE<1>
You might be able to use @AM in place of CHAR(254) depending on your MVDB
version.
Hope this helps.
Joe Goldthwaite
On Thu, Feb 2, 2023 at 10:23 AM Kimberly Crum via Rocket Forum <
Mail@forum.rocketsoftware.com> wrote:
> I am being asked to break a tab delimited file as part of an assessment.
> How do I identify the tab delimiter? ------------------------------...
> -posted to the "MultiValue Tools" forum
> Invite your colleagues to join the Rocket Forum and grow our expert
> network.
> ------------------------------
> [image: Rocket Software] <https: community.rocketsoftware.com="">
> MultiValue Tools
> <https: community.rocketsoftware.com/forums/forum-home/digestviewer?communitykey="9623ec16-9dfa-45ef-b0ef-482ea8980f44">
> Post New Message Online
> <http: community.rocketsoftware.com/participate/postmessage?groupid="133">
> Invite your colleagues to join the Rocket Forum and grow our expert
> network. Share this link. <https: community.rocketsoftware.com/register="">
> Tab delimited file
> <https: community.rocketsoftware.com/discussion/tab-delimited-file#bm0b24be3a-a9fa-488d-a610-519825ddea61="">
> Reply to Group Online
> <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="0b24be3a-a9fa-488d-a610-519825ddea61&ListKey=c397ae29-dbd0-4bf0-9a33-748df2e87c34"> Reply
> to Group
> <
rocket_mvtools1_0b24be3a-a9fa-488d-a610-519825ddea61@connectedcommunity.org?subject=re:+tab+delimited+file>
> [image: Kimberly Crum]
> <https: community.rocketsoftware.com/network/members/profile?userkey="5adde1a6-f7eb-48d9-abde-018609f2255d">
> Feb 2, 2023 12:24 PM
> Kimberly Crum
> <https: community.rocketsoftware.com/network/members/profile?userkey="5adde1a6-f7eb-48d9-abde-018609f2255d">
> I am being asked to break a tab delimited file as part of an assessment.
> How do I identify the tab delimiter?
>
> ------------------------------
> Kimberly Crum
> Rocket Forum Shared Account
> ------------------------------
> *Reply to Group Online
> <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="0b24be3a-a9fa-488d-a610-519825ddea61&ListKey=c397ae29-dbd0-4bf0-9a33-748df2e87c34">*
> *View Thread
> <https: community.rocketsoftware.com/discussion/tab-delimited-file#bm0b24be3a-a9fa-488d-a610-519825ddea61="">*
> *Forward
> <https: community.rocketsoftware.com/forums/all-discussions/forwardmessages?messagekey="0b24be3a-a9fa-488d-a610-519825ddea61&ListKey=c397ae29-dbd0-4bf0-9a33-748df2e87c34">*
> *Flag as Inappropriate
> <https: community.rocketsoftware.com/discussion/tab-delimited-file?markappropriate="0b24be3a-a9fa-488d-a610-519825ddea61#bm0b24be3a-a9fa-488d-a610-519825ddea61">*
> *Post New Message Online
> <http: community.rocketsoftware.com/participate/postmessage?groupid="133">*
>
>
>
>
> You are subscribed to "MultiValue Tools" as
joe@goldthwaites.com. To
> change your subscriptions, go to My Subscriptions
> <https: community.rocketsoftware.com/preferences?section="Subscriptions">.
> To unsubscribe from this community discussion, go to Unsubscribe
> <https: community.rocketsoftware.com/higherlogic/egroups/unsubscribe.aspx?userkey="3873a97d-2498-4a32-a1f4-43821dddc57c&sKey=KeyRemoved&GroupKey=c397ae29-dbd0-4bf0-9a33-748df2e87c34">
> .
>
Original Message:
Sent: 1/31/2023 6:38:00 PM
From: Kimberly Crum
Subject: Tab delimited file
I am being asked to break a tab delimited file as part of an assessment. How do I identify the tab delimiter?
------------------------------
Kimberly Crum
Rocket Forum Shared Account
------------------------------
</https:></https:></http:></https:></https:></https:></https:></https:></https:></rocket_mvtools1_0b24be3a-a9fa-488d-a610-519825ddea61@connectedcommunity.org?subject=re:+tab+delimited+file></https:></https:></https:></http:></https:></https:>